Import Budget

The first page of the import allows the user to define the import defaults, import type, and file location:

1. Select the Budget Year. This value is required. The field contains all budget fiscal years defined in the system. The current budget year is the default value.
2. The Override Budget Level value is the budget level that should be populated with the imported information if no budget level is defined for the transaction. The field is populated with all budget levels defined in System Settings. The field is blank by default.
3. The Import Type value defines the location and function to execute over the customer-specific data when the import is run. This value is required. The field is populated with all Import Budget File import types. The field is blank by default.
4. The Import File Name/Location control is the path where the import file can be found and the file name itself. Use the button to locate the file. This field is enabled and required when an Import Type is specified. The path may contain up to 256 characters.
5. The Translation Account Group field is used to cross-reference the G/L account number being imported to the G/L account number defined in the system. The control is populated with all entries from the Translation Account Group validation set. The control is optional and is blank by default.
6. Click Next to go on to the second page.

The second page of the import process contains all transactions with validation errors and a summary of the valid transactions. It allows the user to correct budget accounts with errors and allows the user to complete the import.

1. The Processing Options section allows the user to define which edit and audit reports to generate and whether to complete the import.
   1. The Import Budget Transactions check box must be selected for the import to occur. The default value is determined by the validation results. If there are valid transactions and the validation returned no error messages, this check box is selected by default. It is deselected if some of the rows returned contain error messages. If all of the rows contain errors, the check box is deselected and disabled.
   2. The Print Budget Import Audit Listing check box determines whether the audit listing will be generated. This listing contains every valid budget account and transaction that will be part of the imported batch. The default value is determined by the validation results. If there are valid transactions and the validation returned no error messages, this check box is selected by default. It is deselected if some of the rows returned contain error messages. If all of the rows contain errors, the check box is deselected and disabled.
   3. The Print Budget Import Error Listing check box determines whether the error listing will be generated. This listing contains every valid budget account and transaction in the import table that has either an error or a warning message associated to it. The default value is determined by the validation results. If any warning or error messages exist, this check box is selected by default. It is deselected if some no warning or error messages exist.
2. The Result Summary section shows all valid budget import account transactions summarized by fund and budget level.

• The Fund column displays the code assigned to the fund.
• The Description column displays the name of the fund.
• The Budget Level column displays the name of the budget level to which the amounts are being imported.
• The Count column displays the total number of budget account transactions for the fund for the specific budget level represented by that row.
• The Revenue Amount column displays the total amount of the revenue budget account transactions for the fund and budget level.
• The Expense Amount column displays the total amount of the revenue budget account transactions for the fund and budget level.
• The Net Difference column displays the net difference of the revenue and the expense amounts for the fund and budget level.

3. The Results in Error section lists the validation errors and warning mes-sages for affected budget transactions. The list is sorted by G/L Account.

• The G/L Account column displays the account number associated with the transaction that returned an error message.
• The Budget Level column displays the name of the budget level associated with the transaction.
• The Budget Amount column displays the amount associated with the transaction.
• The Message column displays the primary error message that the validation returned for this transaction.
• The Multiple Errors column will display a icon if additional errors or warnings were created for the transaction. Clicking on the icon will launch a pop-up page that displays the other messages.

4. Click the Finish button to continue. Clicking this button completes all page validations and imports the valid transactions and runs the reports as indicated by the check boxes on this screen. A version of the import file is attached in the form of a document to the header file.

The final page of the import is a confirmation page that the import has completed successfully.